package com.frog.rss.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class RssSQLiteOpenHelper extends SQLiteOpenHelper {
	public final static String DATABASE_NAME = "frog_rss";
	public final static String RSS_ITEM_TABLE_NAME = "rss_item";
	public final static int DATABASE_VERSION = 1;

	final static String CREATE_DABABASE = "create table "
			+ RSS_ITEM_TABLE_NAME
			+ " (id integer primary key autoincrement, " +
					"title varchar(255), " +
					"link varchar(255), " +
					"pubDate varchar(100), " +
					"description varchar(10000), " +
					"category varchar(255), " +
					"starrted integer, " +
					"read integer ) ";

	public RssSQLiteOpenHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CREATE_DABABASE);
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {

	}

}
